#!/usr/bin/env bash

PASSWD_TEST="R4G2Ee4c"
HOST_TEST="test20220812-2.cauntyvm1sxg.eu-central-1.rds.amazonaws.com"
DOMAIN_ID="9"


for i in `seq 1 16`
do
    mysql -uroot -p$PASSWD_TEST -h$HOST_TEST -e "ALTER TABLE julink_warehouse.${DOMAIN_ID}_julink_warehouse_${i} ADD pem_version INT DEFAULT 0 COMMENT '根证书版本号';"
    mysql -uroot -p$PASSWD_TEST -h$HOST_TEST -e "show create table julink_warehouse.${DOMAIN_ID}_julink_warehouse_${i}" | grep "pem_version"
done